Home:ALL Converter>Unable to filter service bus topic messages using SqlFilter

Unable to filter service bus topic messages using SqlFilter

Ask Time:2018-11-16T12:28:18         Author:vamshi s

Json Formatter

I've subscribed to a topic and the sender sets two UserProperties 'Classification' and 'SubClassification'. I want to filter the messages with Classification set to 1. I tried adding the following SqlFilter.

SqlFilter("Classification='1'")

It doesn't work. I still receive all the messages irrespective of the 'Classification' property.

I'm using the Subscription client from Microsoft.Azure.ServiceBus namespace.

Author:vamshi s,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/53331464/unable-to-filter-service-bus-topic-messages-using-sqlfilter
Arunprabhu :

You don't need to use SqlFilter() inside the Rule. Just setting it as Classification='1' will filter the messages.",
2018-11-16T04:55:18
yy